MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Object Name = 98

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Title, Culture, Artist Role, Artist Nationality, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, City, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
499 67.262.1a–c 0 1 559 American Decorative Arts 1 Bookcase 98 Bookcase American 1                           1835–50 1835 1850 Mahogany, pine 184 91 1/4 x 49 x 27 3/8 in. (231.8 x 124.5 x 69.5 cm) Gift of John C. Cattus, 1967 Made in 1 New York 3     United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
500 1977.310.1 0 1 560 American Decorative Arts 1 Bookcase 98 Bookcase American 1                           ca. 1855 1852 1855 Oak, pine 185 95 1/2 x 60 x 22 in. (242.6 x 152.4 x 55.9 cm) Sansbury-Mills Fund, 1977 Made in 1       United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
501 1977.310.2 0 1 561 American Decorative Arts 1 Bookcase 98 Bookcase American 1                           ca. 1855 1852 1855 Oak, pine 185 95 1/2 x 60 x 21 1/2 in. (242.6 x 152.4 x 54.6 cm) Sansbury-Mills Fund, 1977 Made in 1       United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
10812 1992.181.2 0 1 11794 American Decorative Arts 1 Bookcase 98 Bookcase American 1                           1765–75 1765 1775 Mahogany 45 55 x 46 x 15 5/8 in. (139.7 x 116.8 x 39.7 cm) Gift of Bernard and S. Dean Levy, Inc., New York City, in honor of Bernard Levy, 1992 Made in 1 Philadelphia 1     United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
116390 69.9.2 0 1 205092 European Sculpture and Decorative Arts 3 Bookcase 98 Bookcase French, Paris 114         Maker 1   Martin Carlin French, near Freiburg im Breisgau ca. 1730–1785 Paris   Carlin, Martin 11299 French 2 1725 1785 ca. 1785 1780 1790 Tulipwood and satiné on oak; glass, and gilt-bronze mounts 23124 Overall: 80 × 44 3/4 × 16 in. (203.2 × 113.7 × 40.6 cm) Bequest of Mary Hayward Weir, 1968                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
121704 Inst.66.12 0 1 211382 European Sculpture and Decorative Arts 3 Bookcase 98 Bookcase British 6                           ca. 1710 1705 1715 Walnut, mahogany (?) 24259 71 3/4 × 43 1/2 × 14 1/2 in. (182.2 × 110.5 × 36.8 cm) Gift of Mrs. Richard S. Perkins, 1966                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
335076 1982.30ab 1 0 482533 Modern and Contemporary Art 4 Bookcase 98 Skyscraper           Designer 5   Paul T. Frankl American, Vienna 1886–1958 Los Angeles, California   Frankl, Paul T. 45277 American 1 1886 1958 ca. 1927 1925 1930 Maple, Bakelite  51225 Overall: 80 1/4 × 34 1/4 × 18 7/8 in., Weight: 153 lb. (203.8 × 87 × 47.9 cm, 69.4 kg) Base: 30 1/2 × 34 1/4 × 18 7/8 in., Weight: 83 lb. (77.5 × 87 × 47.9 cm, 37.6 kg) Top: 49 3/4 × 30 1/2 × 17 in., Weight: 70 lb. (126.4 × 77.5 × 43.2 cm, 31.8 kg) Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1982                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
343066 2000.666a-e 0 0 491809 Modern and Contemporary Art 4 Bookcase 98 Bookcase           Designer 5   Rupert Carabin French, 1862–1932   Carabin, Rupert 45105 French 2 1862 1932 1905 1905 1905 Pearwood, glass, metal 53117 H. 65, W. 61-5/8, D. 19-1/2 in. (165.1 x 156.5 x 49.5 cm) Gift of Eva and Michael Chow, 2000                       Furniture-Wood 883   Metropolitan Museum of Art, New York, NY 1
422235 SL.14.2015.19.1 0 0 700210 American Decorative Arts 1 Bookcase 98 Bookcase from the library of the Worsham-Rockefeller House American 1         Maker|Maker 6   George A. Schastey|George A. Schastey & Co. 1839–1894|1873–97   Schastey, George A.|George A. Schastey & Co. 2567   1839 |1873 1894 |1897 1881–82 1881 1882 Mahogany, brass, and glass 60452 54 1/2 × 54 × 20 in. (138.4 × 137.2 × 50.8 cm) Collection of Margot Johnson Made in 1 New York 3     United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 127.646ms · Data license: CC0 · Data source: metmuseum/openaccess